package com.hz.house.dao;

import com.hz.house.bean.entity.CityTradeInfoBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CityHouseTradeHistoryMapper {

    @Select("SELECT id, city_name cityName, area, count,sort, update_date updateDate FROM qb_house_city_trade_history WHERE TO_DAYS(update_date) = (SELECT MAX(TO_DAYS(update_date)) FROM qb_house_city_trade_history) ORDER BY sort ASC")
    List<CityTradeInfoBean> selectNestLog();
}
